Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	24865
Missing cells	306043
Missing cells (%)	37.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.3 MiB
Average record size in memory	264.0 B

Variable types

NUM	17
CAT	12
BOOL	2
UNSUPPORTED	2

Warnings

`dom` has a high cardinality: 23278 distinct values	High cardinality
`opscope` has a high cardinality: 20812 distinct values	High cardinality
`opfrom` has a high cardinality: 6620 distinct values	High cardinality
`opto` has a high cardinality: 5746 distinct values	High cardinality
`oploc` has a high cardinality: 5351 distinct values	High cardinality
`enttypeitem` is highly correlated with `enttype` and 2 other fields	High correlation
`enttype` is highly correlated with `enttypeitem` and 2 other fields	High correlation
`enttypeminu` is highly correlated with `enttype` and 2 other fields	High correlation
`forregcap` is highly correlated with `parnum` and 1 other fields	High correlation
`parnum` is highly correlated with `forregcap`	High correlation
`congro` is highly correlated with `forregcap`	High correlation
`enttypegb` is highly correlated with `enttype` and 2 other fields	High correlation
`enttypeitem` has 8214 (33.0%) missing values	Missing
`opto` has 16040 (64.5%) missing values	Missing
`empnum` has 5250 (21.1%) missing values	Missing
`compform` has 14234 (57.2%) missing values	Missing
`parnum` has 22526 (90.6%) missing values	Missing
`exenum` has 23487 (94.5%) missing values	Missing
`opform` has 15866 (63.8%) missing values	Missing
`ptbusscope` has 24865 (100.0%) missing values	Missing
`venind` has 16428 (66.1%) missing values	Missing
`enttypeminu` has 17595 (70.8%) missing values	Missing
`midpreindcode` has 24865 (100.0%) missing values	Missing
`protype` has 24831 (99.9%) missing values	Missing
`reccap` has 17781 (71.5%) missing values	Missing
`forreccap` has 24638 (99.1%) missing values	Missing
`forregcap` has 24615 (99.0%) missing values	Missing
`congro` has 24616 (99.0%) missing values	Missing
`empnum` is highly skewed (γ1 = 64.09544801)	Skewed
`exenum` is highly skewed (γ1 = 37.12059194)	Skewed
`regcap` is highly skewed (γ1 = 37.58223561)	Skewed
`dom` is uniformly distributed	Uniform
`opto` is uniformly distributed	Uniform
`id` has unique values	Unique
`ptbusscope` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`midpreindcode` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`empnum` has 1100 (4.4%) zeros	Zeros
`reccap` has 3641 (14.6%) zeros	Zeros

Reproduction

Analysis started	2020-12-01 09:18:44.266611
Analysis finished	2020-12-01 09:20:19.222340
Duration	1 minute and 34.96 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

id
Categorical

UNIQUE

Distinct	24865
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

82750f1b9d122350631f2f1a07ab9386fdc3bbe8405dee2a	1
82750f1b9d12235051914b2ff47de9503ecb724a0685976c	1
da8691b210adb3f6f930cba2d98cbd1fab4b3514f5dac26f	1
d8071a739aa75a3be52776eaab98e82d9d2dfc8fff11b906	1
516ab81418ed215d7ff88dff6078f5b662836a2fa66329f5	1
Other values (24860)	24860

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
82750f1b9d122350631f2f1a07ab9386fdc3bbe8405dee2a	1	< 0.1%
82750f1b9d12235051914b2ff47de9503ecb724a0685976c	1	< 0.1%
da8691b210adb3f6f930cba2d98cbd1fab4b3514f5dac26f	1	< 0.1%
d8071a739aa75a3be52776eaab98e82d9d2dfc8fff11b906	1	< 0.1%
516ab81418ed215d7ff88dff6078f5b662836a2fa66329f5	1	< 0.1%
beb4aaaa89e0a0ae66f0bec42a60df9481549f3d5eefa811	1	< 0.1%
516ab81418ed215d8167596332520a089f98990d0d6ff850	1	< 0.1%
e9f7b28ec10e04704615292762fabc03c0da5451faa52c17	1	< 0.1%
beb4aaaa89e0a0ae4270c78593a2fc3ea64441dd372d31a9	1	< 0.1%
f000950527a6feb6b03cf0c5c7020228573603098f4b891a	1	< 0.1%
Other values (24855)	24855	> 99.9%

Frequencies of value counts

Unique

Unique	24865 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	48
Median length	48
Mean length	48
Min length	48

oplocdistrict
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	340210.5369
Minimum	340000
Maximum	340294
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	340000
5-th percentile	340200
Q1	340202
median	340207
Q3	340221
95-th percentile	340225
Maximum	340294
Range	294
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.81857312
Coefficient of variation (CV)	3.767835422e-05
Kurtosis	18.44865257
Mean	340210.5369
Median Absolute Deviation (MAD)	5
Skewness	1.377265426
Sum	8459334999
Variance	164.3158168
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
340202	5481	22.0%
340207	4120	16.6%
340200	3442	13.8%
340203	3007	12.1%
340225	2444	9.8%
340221	2092	8.4%
340223	1803	7.3%
340222	1338	5.4%
340208	630	2.5%
340271	426	1.7%
Other values (6)	82	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
340000	4	< 0.1%
340200	3442	13.8%
340201	39	0.2%
340202	5481	22.0%
340203	3007	12.1%

Value	Count	Frequency (%)
340294	1	< 0.1%
340272	36	0.1%
340271	426	1.7%
340225	2444	9.8%
340224	1	< 0.1%

industryphy
Categorical

Distinct	20
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

O	10312
M	7017
R	2968
L	1428
J	1130
Other values (15)	2010

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
O	10312	41.5%
M	7017	28.2%
R	2968	11.9%
L	1428	5.7%
J	1130	4.5%
P	625	2.5%
N	567	2.3%
Q	382	1.5%
F	114	0.5%
K	87	0.3%
Other values (10)	235	0.9%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

industryco
Real number (ℝ_≥0)

Distinct	345
Distinct (%)	1.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	7885.261141
Minimum	0
Maximum	9700
Zeros	2
Zeros (%)	< 0.1%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	6790
Q1	7512
median	8040
Q3	8199
95-th percentile	8930
Maximum	9700
Range	9700
Interquartile range (IQR)	687

Descriptive statistics

Standard deviation	667.0475452
Coefficient of variation (CV)	0.08459422375
Kurtosis	17.69240112
Mean	7885.261141
Median Absolute Deviation (MAD)	450
Skewness	-2.126484947
Sum	196059133
Variance	444952.4276
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8090	3093	12.4%
8290	1899	7.6%
8040	1813	7.3%
7519	1497	6.0%
7590	1307	5.3%
8111	1026	4.1%
7499	921	3.7%
7320	829	3.3%
6760	781	3.1%
8890	769	3.1%
Other values (335)	10929	44.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
73	1	< 0.1%
89	1	< 0.1%
111	2	< 0.1%
141	2	< 0.1%

Value	Count	Frequency (%)
9700	1	< 0.1%
9620	1	< 0.1%
9412	1	< 0.1%
9291	2	< 0.1%
9225	1	< 0.1%

dom
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	23278
Distinct (%)	93.6%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

746df9aaed85785750564fb51c89c9c469347cef8c39195aa799082630881cfb19caa98fbb1572e2fb017e3568e479c31dec4a40478455f8	22
31487d8f256f16bd6244b7251be2ebb227ca54d864983f5d533d505d4e0d1ec9a4d6553d4439c868f7f1b6346371b63aa4fe635720f130b0	20
ca213febe80e171c3b9617e39b49d64eb1d41d39955a4494d2ca4fb0d71b236d664e8b882330b8a6	18
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783004837606b751aad0045609b733c27c0a26dfcf4f5a5528e1f77b54e7fe0652705b1979601dfee1c8982361cb59f1d005782249a6d6eb156a4908ee17f78b7e3649728a29f38c545	17
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b1e0da20e2aa30dc70bc1eeb69e2ce688edfb053255a8ab815	15
Other values (23273)	24773

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
746df9aaed85785750564fb51c89c9c469347cef8c39195aa799082630881cfb19caa98fbb1572e2fb017e3568e479c31dec4a40478455f8	22	0.1%
31487d8f256f16bd6244b7251be2ebb227ca54d864983f5d533d505d4e0d1ec9a4d6553d4439c868f7f1b6346371b63aa4fe635720f130b0	20	0.1%
ca213febe80e171c3b9617e39b49d64eb1d41d39955a4494d2ca4fb0d71b236d664e8b882330b8a6	18	0.1%
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783004837606b751aad0045609b733c27c0a26dfcf4f5a5528e1f77b54e7fe0652705b1979601dfee1c8982361cb59f1d005782249a6d6eb156a4908ee17f78b7e3649728a29f38c545	17	0.1%
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b1e0da20e2aa30dc70bc1eeb69e2ce688edfb053255a8ab815	15	0.1%
31487d8f256f16bd6244b7251be2ebb210b4e8f49f9331b0ab5741bea91606d9f42620fe82d891701e0d4018709b564e1ef0ec2f03b120e8	15	0.1%
ca213febe80e171cf62c2ed671ebb5cb3432a52e67b170cb328e09384a40eaaf32b791a101af85856570013914ba7137	15	0.1%
ca213febe80e171c3b9617e39b49d64eb1d41d39955a4494ee140c20d835dca2f8c73c67247f94b5	15	0.1%
746df9aaed85785750564fb51c89c9c469347cef8c39195aa799082630881cfba6a0026ec3b03ebe	13	0.1%
746df9aaed85785750564fb51c89c9c469347cef8c39195aa799082630881cfb19caa98fbb1572e2fb017e3568e479c3661bad53f846d1b1	12	< 0.1%
Other values (23268)	24703	99.3%

Frequencies of value counts

Unique

Unique	22335 ?
Unique (%)	89.8%

Histogram of lengths of the category

Length

Max length	432
Median length	128
Mean length	137.6656344
Min length	48

opscope
Categorical

HIGH CARDINALITY

Distinct	20812
Distinct (%)	83.7%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

室内装修服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	189
理发服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	113
足浴服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	82
企业投资（涉及前置许可的除外）。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	68
理发服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）	65
Other values (20807)	24348

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
室内装修服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	189	0.8%
理发服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	113	0.5%
足浴服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	82	0.3%
企业投资（涉及前置许可的除外）。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	68	0.3%
理发服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）	65	0.3%
美发服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	62	0.2%
美容服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	61	0.2%
美容服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）	56	0.2%
洗浴服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	51	0.2%
足浴服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）	47	0.2%
Other values (20802)	24071	96.8%

Frequencies of value counts

Unique

Unique	19633 ?
Unique (%)	79.0%

Histogram of lengths of the category

Length

Max length	973
Median length	66
Mean length	89.97084255
Min length	3

enttype
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	17
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4229.008647
Minimum	1100
Maximum	9600
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1100
5-th percentile	1100
Q1	1100
median	1100
Q3	9600
95-th percentile	9600
Maximum	9600
Range	8500
Interquartile range (IQR)	8500

Descriptive statistics

Standard deviation	3892.282453
Coefficient of variation (CV)	0.9203770383
Kurtosis	-1.564518628
Mean	4229.008647
Median Absolute Deviation (MAD)	0
Skewness	0.5707719966
Sum	105154300
Variance	15149862.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1100	14085	56.6%
9600	8193	32.9%
4500	2180	8.8%
2100	141	0.6%
1200	81	0.3%
2200	40	0.2%
3100	37	0.1%
3200	29	0.1%
9100	23	0.1%
5100	20	0.1%
Other values (7)	36	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1100	14085	56.6%
1200	81	0.3%
2100	141	0.6%
2200	40	0.2%
3100	37	0.1%

Value	Count	Frequency (%)
9600	8193	32.9%
9100	23	0.1%
6800	2	< 0.1%
6100	19	0.1%
5800	3	< 0.1%

enttypeitem
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	31
Distinct (%)	0.2%
Missing	8214
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%

Mean	1646.959942
Minimum	1110
Maximum	9600
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1110
5-th percentile	1130
Q1	1130
median	1150
Q3	1150
95-th percentile	4540
Maximum	9600
Range	8490
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	1276.284531
Coefficient of variation (CV)	0.77493356
Kurtosis	7.185926114
Mean	1646.959942
Median Absolute Deviation (MAD)	20
Skewness	2.588714536
Sum	27423530
Variance	1628902.205
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1130	7467	30.0%
1150	5679	22.8%
4530	1422	5.7%
1190	843	3.4%
4540	757	3.0%
1220	79	0.3%
1110	79	0.3%
2130	77	0.3%
9600	71	0.3%
2150	36	0.1%
Other values (21)	141	0.6%
(Missing)	8214	33.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1110	79	0.3%
1120	10	< 0.1%
1130	7467	30.0%
1140	7	< 0.1%
1150	5679	22.8%

Value	Count	Frequency (%)
9600	71	0.3%
6810	2	< 0.1%
6180	1	< 0.1%
6150	4	< 0.1%
6120	1	< 0.1%

opfrom
Categorical

HIGH CARDINALITY

Distinct	6620
Distinct (%)	26.6%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

2019-12-11 00:00:00	38
2018-03-07	36
2019-11-27 00:00:00	34
2019-12-04 00:00:00	34
2019-12-16 00:00:00	34
Other values (6615)	24689

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-12-11 00:00:00	38	0.2%
2018-03-07	36	0.1%
2019-11-27 00:00:00	34	0.1%
2019-12-04 00:00:00	34	0.1%
2019-12-16 00:00:00	34	0.1%
2019-11-07 00:00:00	33	0.1%
2019-04-25	33	0.1%
2019-11-21 00:00:00	33	0.1%
2019-04-08	33	0.1%
2019-12-05 00:00:00	32	0.1%
Other values (6610)	24525	98.6%

Frequencies of value counts

Unique

Unique	3348 ?
Unique (%)	13.5%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	14.7723708
Min length	10

opto
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	5746
Distinct (%)	65.1%
Missing	16040
Missing (%)	64.5%
Memory size	194.3 KiB

2022-10-31	24
2029-08-15	16
2029-04-24	15
2046-12-06	14
2026-05-15	13
Other values (5741)	8743

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2022-10-31	24	0.1%
2029-08-15	16	0.1%
2029-04-24	15	0.1%
2046-12-06	14	0.1%
2026-05-15	13	0.1%
2023-02-17	13	0.1%
2047-12-25	13	0.1%
2023-01-05	11	< 0.1%
2026-01-26	10	< 0.1%
2015-05-15 00:00:00	10	< 0.1%
Other values (5736)	8686	34.9%
(Missing)	16040	64.5%

Frequencies of value counts

Unique

Unique	4127 ?
Unique (%)	46.8%

Histogram of lengths of the category

Length

Max length	19
Median length	3
Mean length	6.817856425
Min length	3

state
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.164568671
Minimum	4
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	4
5-th percentile	6
Q1	6
median	6
Q3	6
95-th percentile	7
Maximum	20
Range	16
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5822263236
Coefficient of variation (CV)	0.09444721192
Kurtosis	79.96544229
Mean	6.164568671
Median Absolute Deviation (MAD)	0
Skewness	7.510151697
Sum	153282
Variance	0.3389874919
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	21583	86.8%
7	3109	12.5%
11	104	0.4%
13	65	0.3%
4	3	< 0.1%
20	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	3	< 0.1%
6	21583	86.8%
7	3109	12.5%
11	104	0.4%
13	65	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
13	65	0.3%
11	104	0.4%
7	3109	12.5%
6	21583	86.8%

orgid
Real number (ℝ_≥0)

Distinct	78
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.416681858e+17
Minimum	1.4108e+17
Maximum	4e+17
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1.4108e+17
5-th percentile	3.402e+17
Q1	3.402e+17
median	3.4020201e+17
Q3	3.4020701e+17
95-th percentile	3.4022301e+17
Maximum	4e+17
Range	2.5892e+17
Interquartile range (IQR)	7.010009883e+12

Descriptive statistics

Standard deviation	1.107348844e+16
Coefficient of variation (CV)	0.03241006596
Kurtosis	95.65478901
Mean	3.416681858e+17
Median Absolute Deviation (MAD)	2.010009888e+12
Skewness	-0.3781296071
Sum	-8.369577417e+18
Variance	1.226221462e+32
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.4020201e+17	3617	14.5%
3.4020701e+17	2892	11.6%
3.402e+17	2261	9.1%
3.4020301e+17	2098	8.4%
3.4022101e+17	1361	5.5%
3.4020017e+17	1113	4.5%
3.402e+17	1078	4.3%
3.4022301e+17	929	3.7%
3.4022201e+17	662	2.7%
3.402e+17	549	2.2%
Other values (68)	8305	33.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.4108e+17	18	0.1%
3.402e+17	2261	9.1%
3.402e+17	36	0.1%
3.402e+17	431	1.7%
3.402e+17	64	0.3%

Value	Count	Frequency (%)
4e+17	20	0.1%
4e+17	27	0.1%
4e+17	166	0.7%
4e+17	11	< 0.1%
4e+17	271	1.1%

jobid
Real number (ℝ_≥0)

Distinct	434
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.548101216e+17
Minimum	1.4108e+17
Maximum	4e+17
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1.4108e+17
5-th percentile	3.402e+17
Q1	3.402e+17
median	3.402e+17
Q3	4e+17
95-th percentile	4e+17
Maximum	4e+17
Range	2.5892e+17
Interquartile range (IQR)	5.98e+16

Descriptive statistics

Standard deviation	3.052366894e+16
Coefficient of variation (CV)	0.0860281798
Kurtosis	11.15271658
Mean	3.548101216e+17
Median Absolute Deviation (MAD)	19889792
Skewness	-1.068803396
Sum	4.810006954e+18
Variance	9.316943655e+32
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.402e+17	1783	7.2%
3.402e+17	1703	6.8%
3.402e+17	1177	4.7%
3.402e+17	1035	4.2%
4e+17	831	3.3%
3.402e+17	544	2.2%
3.402e+17	535	2.2%
3.402e+17	497	2.0%
4e+17	363	1.5%
3.402e+17	356	1.4%
Other values (424)	16041	64.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.4108e+17	2	< 0.1%
1.4108e+17	1	< 0.1%
1.4108e+17	61	0.2%
1.4108e+17	69	0.3%
3.4e+17	3	< 0.1%

Value	Count	Frequency (%)
4e+17	1	< 0.1%
4e+17	32	0.1%
4e+17	1	< 0.1%
4e+17	62	0.2%
4e+17	110	0.4%

adbusign
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

0	24795
1	70

Common Values
Chart

Value	Count	Frequency (%)
0	24795	99.7%
1	70	0.3%

townsign
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

1	14383
0	10482

Common Values
Chart

Value	Count	Frequency (%)
1	14383	57.8%
0	10482	42.2%

regtype
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

1	23792
3	1025
4	48

Frequencies
Length

Value	Count	Frequency (%)
1	23792	95.7%
3	1025	4.1%
4	48	0.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

empnum
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	62
Distinct (%)	0.3%
Missing	5250
Missing (%)	21.1%
Infinite	0
Infinite (%)	0.0%

Mean	4.397960744
Minimum	0
Maximum	1500
Zeros	1100
Zeros (%)	4.4%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	3
Q3	5
95-th percentile	10
Maximum	1500
Range	1500
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	15.38920562
Coefficient of variation (CV)	3.499168481
Kurtosis	5515.640328
Mean	4.397960744
Median Absolute Deviation (MAD)	1
Skewness	64.09544801
Sum	86266
Variance	236.8276496
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5284	21.3%
2	4678	18.8%
1	2308	9.3%
5	2059	8.3%
4	1213	4.9%
0	1100	4.4%
10	863	3.5%
6	631	2.5%
8	307	1.2%
20	217	0.9%
Other values (52)	955	3.8%
(Missing)	5250	21.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1100	4.4%
1	2308	9.3%
2	4678	18.8%
3	5284	21.3%
4	1213	4.9%

Value	Count	Frequency (%)
1500	1	< 0.1%
1000	1	< 0.1%
500	1	< 0.1%
300	1	< 0.1%
218	1	< 0.1%

compform
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	14234
Missing (%)	57.2%
Memory size	194.3 KiB

1	10610
2	21

Frequencies
Length

Value	Count	Frequency (%)
1	10610	42.7%
2	21	0.1%
(Missing)	14234	57.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

parnum
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	51
Distinct (%)	2.2%
Missing	22526
Missing (%)	90.6%
Infinite	0
Infinite (%)	0.0%

Mean	4.587430526
Minimum	0
Maximum	100
Zeros	3
Zeros (%)	< 0.1%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	23.1
Maximum	100
Range	100
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	8.752046576
Coefficient of variation (CV)	1.907831961
Kurtosis	18.62224191
Mean	4.587430526
Median Absolute Deviation (MAD)	0
Skewness	4.094078848
Sum	10730
Variance	76.59831927
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1230	4.9%
1	399	1.6%
3	293	1.2%
4	96	0.4%
5	49	0.2%
6	30	0.1%
7	21	0.1%
8	13	0.1%
13	13	0.1%
44	11	< 0.1%
Other values (41)	184	0.7%
(Missing)	22526	90.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	399	1.6%
2	1230	4.9%
3	293	1.2%
4	96	0.4%

Value	Count	Frequency (%)
100	1	< 0.1%
50	7	< 0.1%
49	8	< 0.1%
48	4	< 0.1%
47	5	< 0.1%

exenum
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	50
Distinct (%)	3.6%
Missing	23487
Missing (%)	94.5%
Infinite	0
Infinite (%)	0.0%

Mean	77.74963716
Minimum	0
Maximum	100000
Zeros	10
Zeros (%)	< 0.1%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	36.15
Maximum	100000
Range	100000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2693.742692
Coefficient of variation (CV)	34.64636995
Kurtosis	1377.958859
Mean	77.74963716
Median Absolute Deviation (MAD)	0
Skewness	37.12059194
Sum	107139
Variance	7256249.693
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	832	3.3%
2	187	0.8%
3	67	0.3%
5	31	0.1%
4	28	0.1%
6	19	0.1%
12	12	< 0.1%
8	11	< 0.1%
0	10	< 0.1%
10	10	< 0.1%
Other values (40)	171	0.7%
(Missing)	23487	94.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10	< 0.1%
1	832	3.3%
2	187	0.8%
3	67	0.3%
4	28	0.1%

Value	Count	Frequency (%)
100000	1	< 0.1%
50	1	< 0.1%
49	6	< 0.1%
48	8	< 0.1%
47	4	< 0.1%

opform
Categorical

MISSING

Distinct	32
Distinct (%)	0.4%
Missing	15866
Missing (%)	63.8%
Memory size	194.3 KiB

10	8186
01-以个人财产出资	575
01	159
服务	38
租赁	7
Other values (27)	34

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
10	8186	32.9%
01-以个人财产出资	575	2.3%
01	159	0.6%
服务	38	0.2%
租赁	7	< 0.1%
咨询	3	< 0.1%
合	3	< 0.1%
销售	2	< 0.1%
独	2	< 0.1%
02-以家庭共有财产作为个人出资	2	< 0.1%
Other values (22)	22	0.1%
(Missing)	15866	63.8%

Frequencies of value counts

Unique

Unique	22 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	16
Median length	3
Mean length	2.825135733
Min length	1

ptbusscope
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	24865
Missing (%)	100.0%
Memory size	194.4 KiB

venind
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	16428
Missing (%)	66.1%
Memory size	194.3 KiB

3	8115
2	193
1	129

Frequencies
Length

Value	Count	Frequency (%)
3	8115	32.6%
2	193	0.8%
1	129	0.5%
(Missing)	16428	66.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

enttypeminu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	26
Distinct (%)	0.4%
Missing	17595
Missing (%)	70.8%
Infinite	0
Infinite (%)	0.0%

Mean	1824.567538
Minimum	1121
Maximum	4533
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1121
5-th percentile	1151
Q1	1151
median	1151
Q3	1153
95-th percentile	4533
Maximum	4533
Range	3412
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1339.867039
Coefficient of variation (CV)	0.7343477351
Kurtosis	0.3178476875
Mean	1824.567538
Median Absolute Deviation (MAD)	0
Skewness	1.515983494
Sum	13264606
Variance	1795243.682
Monotocity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
1151	4795	19.3%
4533	1371	5.5%
1153	568	2.3%
1152	316	1.3%
4531	50	0.2%
1222	29	0.1%
1229	29	0.1%
2151	22	0.1%
1221	21	0.1%
2153	10	< 0.1%
Other values (16)	59	0.2%
(Missing)	17595	70.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1121	1	< 0.1%
1122	1	< 0.1%
1123	8	< 0.1%
1151	4795	19.3%
1152	316	1.3%

Value	Count	Frequency (%)
4533	1371	5.5%
4532	1	< 0.1%
4531	50	0.2%
2229	7	< 0.1%
2223	1	< 0.1%

midpreindcode
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	24865
Missing (%)	100.0%
Memory size	194.4 KiB

protype
Categorical

MISSING

Distinct	2
Distinct (%)	5.9%
Missing	24831
Missing (%)	99.9%
Memory size	194.3 KiB

99	28
1	6

Frequencies
Length

Value	Count	Frequency (%)
99	28	0.1%
1	6	< 0.1%
(Missing)	24831	99.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	3.001126081
Min length	3

oploc
Categorical

HIGH CARDINALITY

Distinct	5351
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Memory size	194.3 KiB

2367b4cac96d8598	18792
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783bee75565895bdbb5	337
31487d8f256f16bd6244b7251be2ebb2ae36cd652943e86c8f0d6a96cbb90e3b	26
ca213febe80e171cf62c2ed671ebb5cbf19e3fe4b5809fbb	17
31487d8f256f16bd6244b7251be2ebb24d1db51663c654f53b92066f5b24275c	17
Other values (5346)	5676

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2367b4cac96d8598	18792	75.6%
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783bee75565895bdbb5	337	1.4%
31487d8f256f16bd6244b7251be2ebb2ae36cd652943e86c8f0d6a96cbb90e3b	26	0.1%
ca213febe80e171cf62c2ed671ebb5cbf19e3fe4b5809fbb	17	0.1%
31487d8f256f16bd6244b7251be2ebb24d1db51663c654f53b92066f5b24275c	17	0.1%
31487d8f256f16bd6244b7251be2ebb24d1db51663c654f565ba1abf9b63dca00028eddeb16615db	15	0.1%
31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b126d9320b9f534149	14	0.1%
31487d8f256f16bd6244b7251be2ebb2b55c713be7e2b6d14f38dcde5525d37a	13	0.1%
31487d8f256f16bd6244b7251be2ebb287440e1d026a5ecf	8	< 0.1%
ca213febe80e171c5ab458cd1d4bd374ad7fa6e4334fe50a	7	< 0.1%
Other values (5341)	5619	22.6%

Frequencies of value counts

Unique

Unique	5142 ?
Unique (%)	20.7%

Histogram of lengths of the category

Length

Max length	272
Median length	16
Mean length	39.96879147
Min length	16

regcap
Real number (ℝ_≥0)

SKEWED

Distinct	1143
Distinct (%)	4.6%
Missing	191
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	5151.436626
Minimum	0
Maximum	5000100
Zeros	6
Zeros (%)	< 0.1%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	10
Q1	15
median	80
Q3	500
95-th percentile	5000
Maximum	5000100
Range	5000100
Interquartile range (IQR)	485

Descriptive statistics

Standard deviation	67770.85757
Coefficient of variation (CV)	13.15571995
Kurtosis	2024.844535
Mean	5151.436626
Median Absolute Deviation (MAD)	70
Skewness	37.58223561
Sum	127106547.3
Variance	4592889136
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	5210	21.0%
100	3054	12.3%
500	2778	11.2%
50	2593	10.4%
20	1653	6.6%
1000	1117	4.5%
200	1028	4.1%
30	1016	4.1%
15	717	2.9%
300	476	1.9%
Other values (1133)	5032	20.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
0.5	2	< 0.1%
0.74	1	< 0.1%
1	5	< 0.1%
2	2	< 0.1%

Value	Count	Frequency (%)
5000100	1	< 0.1%
4004000	1	< 0.1%
2350100	1	< 0.1%
2198560	1	< 0.1%
2129220	1	< 0.1%

reccap
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	597
Distinct (%)	8.4%
Missing	17781
Missing (%)	71.5%
Infinite	0
Infinite (%)	0.0%

Mean	4198.165759
Minimum	0
Maximum	1278900
Zeros	3641
Zeros (%)	14.6%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	100
95-th percentile	10000
Maximum	1278900
Range	1278900
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	36537.97552
Coefficient of variation (CV)	8.703318929
Kurtosis	420.9530509
Mean	4198.165759
Median Absolute Deviation (MAD)	0
Skewness	17.93697486
Sum	29739806.24
Variance	1335023655
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3641	14.6%
50	500	2.0%
100	424	1.7%
10	341	1.4%
500	181	0.7%
1000	170	0.7%
200	168	0.7%
30	147	0.6%
20	109	0.4%
300	73	0.3%
Other values (587)	1330	5.3%
(Missing)	17781	71.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3641	14.6%
0.1	1	< 0.1%
0.2	1	< 0.1%
0.4	1	< 0.1%
0.5	5	< 0.1%

Value	Count	Frequency (%)
1278900	1	< 0.1%
980100	1	< 0.1%
717437	1	< 0.1%
715480	1	< 0.1%
712250	1	< 0.1%

forreccap
Real number (ℝ_≥0)

MISSING

Distinct	11
Distinct (%)	4.8%
Missing	24638
Missing (%)	99.1%
Infinite	0
Infinite (%)	0.0%

Mean	292.6444672
Minimum	0
Maximum	15428.17
Zeros	217
Zeros (%)	0.9%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15428.17
Range	15428.17
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1841.310231
Coefficient of variation (CV)	6.291970078
Kurtosis	52.97308652
Mean	292.6444672
Median Absolute Deviation (MAD)	0
Skewness	7.171911167
Sum	66430.29406
Variance	3390423.368
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	217	0.9%
18.226555	1	< 0.1%
14250	1	< 0.1%
5000	1	< 0.1%
293.785	1	< 0.1%
2103.5	1	< 0.1%
15000	1	< 0.1%
8000	1	< 0.1%
1436.6125	1	< 0.1%
4900	1	< 0.1%
(Missing)	24638	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	217	0.9%
18.226555	1	< 0.1%
293.785	1	< 0.1%
1436.6125	1	< 0.1%
2103.5	1	< 0.1%

Value	Count	Frequency (%)
15428.17	1	< 0.1%
15000	1	< 0.1%
14250	1	< 0.1%
8000	1	< 0.1%
5000	1	< 0.1%

forregcap
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	38
Distinct (%)	15.2%
Missing	24615
Missing (%)	99.0%
Infinite	0
Infinite (%)	0.0%

Mean	1212.583484
Minimum	0
Maximum	88817.92045
Zeros	210
Zeros (%)	0.8%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1109.8875
Maximum	88817.92045
Range	88817.92045
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8113.267914
Coefficient of variation (CV)	6.690894294
Kurtosis	80.3607255
Mean	1212.583484
Median Absolute Deviation (MAD)	0
Skewness	8.678020629
Sum	303145.871
Variance	65825116.25
Monotocity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	210	0.8%
90	2	< 0.1%
300	2	< 0.1%
200	2	< 0.1%
999.75	1	< 0.1%
650	1	< 0.1%
28.33	1	< 0.1%
1490	1	< 0.1%
68	1	< 0.1%
65	1	< 0.1%
Other values (28)	28	0.1%
(Missing)	24615	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	210	0.8%
12	1	< 0.1%
20	1	< 0.1%
28.33	1	< 0.1%
35	1	< 0.1%

Value	Count	Frequency (%)
88817.92045	1	< 0.1%
70000	1	< 0.1%
50000	1	< 0.1%
31500	1	< 0.1%
14250	1	< 0.1%

congro
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	33
Distinct (%)	13.3%
Missing	24616
Missing (%)	99.0%
Infinite	0
Infinite (%)	0.0%

Mean	2805.259428
Minimum	0
Maximum	221453.7613
Zeros	210
Zeros (%)	0.8%
Memory size	194.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4960
Maximum	221453.7613
Range	221453.7613
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18131.95415
Coefficient of variation (CV)	6.463556977
Kurtosis	100.7939374
Mean	2805.259428
Median Absolute Deviation (MAD)	0
Skewness	9.519929349
Sum	698509.5975
Variance	328767761.2
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	210	0.8%
100	3	< 0.1%
500	3	< 0.1%
3000	2	< 0.1%
1000	2	< 0.1%
15000	2	< 0.1%
4500	1	< 0.1%
1420	1	< 0.1%
300	1	< 0.1%
23823.93484	1	< 0.1%
Other values (23)	23	0.1%
(Missing)	24616	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	210	0.8%
100	3	< 0.1%
118	1	< 0.1%
130.1913	1	< 0.1%
140	1	< 0.1%

Value	Count	Frequency (%)
221453.7613	1	< 0.1%
140000	1	< 0.1%
94500	1	< 0.1%
50000	1	< 0.1%
30000	1	< 0.1%

enttypegb
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	53
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4256.337261
Minimum	1110
Maximum	9600
Zeros	0
Zeros (%)	0.0%
Memory size	194.3 KiB

Quantile statistics

Minimum	1110
5-th percentile	1130
Q1	1130
median	1152
Q3	9600
95-th percentile	9600
Maximum	9600
Range	8490
Interquartile range (IQR)	8470

Descriptive statistics

Standard deviation	3873.165231
Coefficient of variation (CV)	0.9099761118
Kurtosis	-1.565109995
Mean	4256.337261
Median Absolute Deviation (MAD)	22
Skewness	0.5700739104
Sum	105833826
Variance	15001408.91
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9600	8193	32.9%
1130	7467	30.0%
1151	4795	19.3%
4533	1371	5.5%
1190	843	3.4%
4540	757	3.0%
1153	568	2.3%
1152	316	1.3%
1110	79	0.3%
2130	77	0.3%
Other values (43)	399	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1110	79	0.3%
1121	1	< 0.1%
1122	1	< 0.1%
1123	8	< 0.1%
1130	7467	30.0%

Value	Count	Frequency (%)
9600	8193	32.9%
9100	23	0.1%
6810	2	< 0.1%
6180	1	< 0.1%
6150	4	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	id	oplocdistrict	industryphy	industryco	dom	opscope	enttype	enttypeitem	opfrom	opto	state	orgid	jobid	townsign	regtype	empnum	compform	parnum	exenum	opform	ptbusscope	venind	enttypeminu	midpreindcode	protype	oploc	regcap	reccap	forreccap	forregcap	congro	enttypegb
0	47645761dc56bb8c5fae00114b768b5d9b6e917c3aec07c4	340223	M	7513.0	31487d8f256f16bd6244b7251be2ebb24d1db51663c654f5cb1ba985b1b19f614bc66f819fed4ac88eca6ca014480058cf714e8d8939efea8d5004822706aaed	纳米新材料、机械设备、五金配件加工、销售及技术推广服务，道路货物运输。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	1100	1150.0	2019-07-11 00:00:00	NaN	6	340223010010000000	340200000000115392	0	1	5.0	NaN	NaN	NaN	NaN	NaN	NaN	1151.0	NaN	NaN	2367b4cac96d8598	50.0	NaN	NaN	NaN	NaN	1151
1	9c7fa510616a683058ce97d0bc768a621cd85ab1e87da2a3	340222	O	8090.0	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783185d7f7a39b7d56bfbe2f7890450d28d236de35f12b8a574	健身服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2017-09-06	NaN	6	340222060010000000	340200000000112114	1	1	3.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783bee75565895bdbb5	10.0	NaN	NaN	NaN	NaN	9600
2	59b38c56de3836838082cfcb1a298951abfe15e6940c49ba	340202	R	9053.0	31487d8f256f16bd6244b7251be2ebb2ae36cd652943e86c796096c38284d710f0f450a398f1b32cfaed0578b903293f40feb9e3800e9d3b	文化娱乐经纪人服务；境内文艺活动组织与策划；文化艺术交流活动组织策划；演出经纪；其他文化艺术经纪代理；文化娱乐经纪人；网络营销策划；市场营销策划；企业形象策划咨询；网上从事企业形象策划服务；企业营销策划；品牌策划服务；广告设计、制作、发布、代理；影视、广播广告发布服务；广告代理服务；互联网广告服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）。	1100	1150.0	2020-09-14 14:46:30	NaN	6	340202010010000000	400000000000753910	0	1	2.0	NaN	1.0	NaN	NaN	NaN	NaN	1151.0	NaN	NaN	2367b4cac96d8598	100.0	NaN	NaN	NaN	NaN	1151
3	e9f7b28ec10e047000d16ab79e1b5e6da434a1697cce7818	340221	L	7212.0	746df9aaed8578571760c563abe882c8ba25209fc6d5db928528265a4b8ce1bb	投资管理及咨询(证券、期货除外)；企业管理。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	4500	4540.0	2015-09-30	NaN	6	340221010010000000	400000000000013538	1	1	2.0	NaN	NaN	NaN	01-以个人财产出资	NaN	NaN	NaN	NaN	NaN	2367b4cac96d8598	10.0	NaN	NaN	NaN	NaN	4540
4	f000950527a6feb63ee1ce82bb22ddd1ab8b8fdffa3b91fb	340202	R	8810.0	31487d8f256f16bd6244b7251be2ebb2ae36cd652943e86cfd2e8fa08b3f80b6e3173f8c796457bf2ebc14ea2d3c1be5cefbd12b724f133dcb205d324d0c6c7fc49cb7baf29b4dfe	境内文化艺术交流活动策划；企业形象策划；礼仪庆典服务；翻译服务；专利代理；广告设计、制作、代理、发布。	1100	1130.0	2017-12-01	2067-11-30	7	340200000000000000	400000000000283237	0	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2367b4cac96d8598	100.0	NaN	NaN	NaN	NaN	1130
5	da8691b210adb3f67820f5e0c87b337d63112cee52211888	340207	R	9019.0	ca213febe80e171c3b9617e39b49d64e79eaa1699bd4df0bf657e28777cc4a4a32b60fbdac651cedc27873991bd1912685cd06d0790f9cf094f21122915a41b8	棋牌娱乐服务；理发服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2019-09-29	NaN	6	340207040010000000	400000000000325767	0	1	1.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	31487d8f256f16bd6244b7251be2ebb2918919c75535b4acd9c73af2e1fc8fec792e3f1dfe3eb8b7aaeefabfad32c3039648a935ac93cceebecddc75459374fc	10.0	NaN	NaN	NaN	NaN	9600
6	9c7fa510616a6830b878f3c8c4317d93e1b022e7f22ae231	340222	O	8052.0	ca213febe80e171cd550f179e9cf5434d53fa8601fba3479972d445b15f25d79c8a2acc2e6df4e9abb0eea691e4e189339d0fa0ec21e73f09c49af65a245e02e654e20e95bf051b0970b8d6f2930f454b0688b2084b35d8147630ad709fdd2074668fbab0fc2adde	足疗服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2020-08-03 00:00:00	NaN	6	340222080010000000	340200000000101006	1	1	5.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	7c29d90151b88c9f396c6c8374278fe7cab4859047594f61cb71ef0d6c3140d4430bf8ff6aa26fa98777f9d3b6df51ac32b4b3a3039b1879625cfaf4b8ba65bd	20.0	NaN	NaN	NaN	NaN	9600
7	9c7fa510616a68309e4badf2a7a3123c0462fb85bf28ef17	340222	O	8111.0	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f5067836603174f887455b47ef07ebbf5832f42305dac0729263fe2a965de5da495c903	汽车维修服务，汽车零配件批发兼零售。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2017-07-10	NaN	6	340222060010000000	340200000000112114	1	1	7.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b19ffcd2880f506783bee75565895bdbb5	15.0	NaN	NaN	NaN	NaN	9600
8	216bd2aaf4d07924b4a106be25791281e2a6d9e54eaee13b	340203	M	7519.0	31487d8f256f16bd6244b7251be2ebb2104d8ea0072d61ed00d47cfe1894ccf82ab2640934f0b38c05fb935d895024964bf780a44b5f3b0c074049e00505f5b107944c8ee155c6626a34be3437d84f2e50c5c34ab5960cb8	机电设备批发；机电设备零售；机电设备安装及维修；太阳能热水器设备及配件、太阳能光伏设备及配件安装及维修；轻质建筑材料批发；钢材批发；包装服务；厨房电器设备批发；厨房电器设备零售；厨房电器设备家电零售；厨房电器设备修理服务；厨卫电器安装及维修；制冷设备批发；制冷设备零售；制冷设备、电热水器、燃气热水器安装及维修；电热水器批发；电热水器修理服务；太阳能与空气源热泵热水系统销售；空气源热泵热水器批发；地源热泵热水器批发；燃气热水器批发；家禽家畜养殖设备和加工设备零售；家禽家畜养殖设备和加工设备的安装及维修；机械设备领域内的技术开发、技术咨询、技术服务；合同能源管理；企业管理咨询；商务信息咨询（依法须经批准的项目，经相关部门批准后方可开展经营活动）。	1100	1190.0	2020-03-10 11:52:15	NaN	6	340203010010000000	400000000000753907	0	1	2.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2367b4cac96d8598	300.0	NaN	NaN	NaN	NaN	1190
9	743e550a617316d5772a00182284976e17d42b6f0ca6d374	340208	O	8051.0	31487d8f256f16bd6244b7251be2ebb2918919c75535b4acecd952004b0eed8590d1b79886892835ecdd4448ba7cecac6c8ca9860b3b887af46275e264fdd4716902044bc738bef1601e9bac0135c7be3a57ce83be0b3425f8a8495a43d86014	足浴服务（依法须经批准的项目，经相关部门批准后方可开展经营活动）。***	9600	NaN	2016-02-29	NaN	6	340206040010000000	340200000020001736	1	1	6.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	ca213febe80e171c6293b0274cbe9e27b4b53b5313603cb1e6bbc2698a15aecad8e09f3ee1b46324	10.0	NaN	NaN	NaN	NaN	9600

Last rows

	id	oplocdistrict	industryphy	industryco	dom	opscope	enttype	enttypeitem	opfrom	opto	state	orgid	jobid	townsign	regtype	empnum	compform	parnum	exenum	opform	ptbusscope	venind	enttypeminu	midpreindcode	protype	oploc	regcap	reccap	forreccap	forregcap	congro	enttypegb
24855	da8691b210adb3f6dff0895152e7e647aab75c3d87bbc110	340207	O	8090.0	31487d8f256f16bd6244b7251be2ebb2b55c713be7e2b6d10feb4a887af2f4d41d5accabadb98dd6d3d1632a796b26adc4d88d1e1e6b6f64f9da3b0bbd67aeaa	房产中介、信息咨询服务**	9600	NaN	2016-11-11	NaN	6	400000000000428947	340200000020002100	1	1	3.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	31487d8f256f16bd6244b7251be2ebb2ae36cd652943e86cd42601efd468eecce1e6ac4b3dc961254bd5c30d13dcbc52cd881eae103972c09a3a6e9d878403b1	10.0	NaN	NaN	NaN	NaN	9600
24856	f000950527a6feb6677343e0c90827f268233b9b1ec2e76c	340200	R	9012.0	31487d8f256f16bd6244b7251be2ebb2104d8ea0072d61ed13cf14f06da95c5e39a2f05b3d1e299ea77987be4c95417893ecf46e545ab536	游艺、电子游戏（许可证有效期至2015年2月22日）。***	1100	1150.0	2012-02-22 00:00:00	2042-02-21 00:00:00	6	340203010010000000	340200000000100093	1	1	3.0	1.0	NaN	NaN	NaN	NaN	NaN	1151.0	NaN	NaN	2367b4cac96d8598	500.0	500.0	NaN	NaN	NaN	1151
24857	59b38c56de38368333bc0aea6c88cd7dae33b1c5cf9e5cc5	340200	R	9013.0	31487d8f256f16bd6244b7251be2ebb245988740fc2130a6f395d2328a7f9d66c38232e5efc771f5	互联网上网服务（网络文化经营许可证有效期限至2015年09月04日）、预包装食品零售（食品流通许可证有效期限至2015年11月27日）。	4500	4540.0	2006-07-20 00:00:00	2015-09-04 00:00:00	7	340202010010000000	340200000020001145	1	1	3.0	1.0	NaN	NaN	01	NaN	NaN	NaN	NaN	NaN	2367b4cac96d8598	40.0	6.0	NaN	NaN	NaN	4540
24858	d8071a739aa75a3b2cf30bec1c008a658963648897cb375b	340200	M	7499.0	ca213febe80e171c3b9617e39b49d64e331b3f25dcbbfc5456eeb6654721b157614a85994154edcd1c3b17e23a3d0a66	自动化设备、气动元器件、机械设备、五金配件、管道阀门、电子产品、通讯设备及配件、建材销售；气动元器件、机械设备安装。（以上范围涉及前置许可的除外）***	1100	1130.0	2014-03-27 00:00:00	2034-03-27 00:00:00	6	340207010010000000	340200000000100093	1	1	3.0	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2367b4cac96d8598	100.0	0.0	NaN	NaN	NaN	1130
24859	f000950527a6feb6de489447885cd6d18f593ec2674174ac	340200	O	8290.0	ca213febe80e171cf62c2ed671ebb5cb1846065a40df80d5d6c200f74683c788dc2f1d595dc4cc77	发放小额贷款，企业财务咨询。	1200	1220.0	2010-08-13	NaN	6	340200000000000000	340200000020000981	1	1	0.0	1.0	NaN	NaN	NaN	NaN	NaN	1222.0	NaN	NaN	2367b4cac96d8598	8000.0	8000.0	NaN	NaN	NaN	1222
24860	f1c1045b13d18329a2bd99d2a7e2227688c0d69bf1d1e325	340225	O	8131.0	31487d8f256f16bd6244b7251be2ebb227ca54d864983f5da11a60e7d55e029af2189b384e2d6799200c3c16b134f4952912488c4e3f459c6e134c96afef8f5458196a01e23a96544b80d11a0c3c4f0863a57308490a3c1a6284b335d944a04516b53f7dc1daea6c777e455155b39306	家电销售、维修及安装服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2009-02-20 00:00:00	NaN	6	340200000000116780	341400000000011622	1	1	3.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	f67c1b92f52ac52e424308ab51241cdef9be3e39c8e1c6cd8525879de055422fbb0cb4c2fb93691f9384792c785698b95fe4f6f3e7c8757f	20.0	NaN	NaN	NaN	NaN	9600
24861	f000950527a6feb6bde38216d7cbbf32e66d3a3a96d4dbda	340207	J	6790.0	31487d8f256f16bdb06579d53b25cbb6c4a6c18662c495d7be6b930ec6c3abdb69ca1256927171b0de6c55cab536ceb6ce430e25660688c3	股权投资，投资管理，投资咨询。（依法须经批准的项目，经相关部门批准后方可开展经营活动）***	4500	4530.0	2015-12-18	2065-12-17	6	340200000000000000	340200000000115797	1	1	2.0	NaN	2.0	1.0	NaN	NaN	NaN	4533.0	NaN	NaN	2367b4cac96d8598	110.0	0.0	NaN	NaN	NaN	4533
24862	da8691b210adb3f65b43370d3a362f4aa1d3b16b5ba0c9d7	340207	O	8111.0	ca213febe80e171c3b9617e39b49d64e4a4abca4f2d760471bf8f7a2e24ec85c9056d9a65f2277f1a206aa3d045cec658dbc38c6ff00a262a4351ce21c6f048f	快速喷漆、电路机维修、汽车美容装潢、汽车维修服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	NaN	2012-05-31 00:00:00	NaN	6	340207030010000000	340200000000115275	1	1	2.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	2367b4cac96d8598	10.0	NaN	NaN	NaN	NaN	9600
24863	516ab81418ed215dcbbf0614a7b929e691f8eed153d7bb31	340225	O	8090.0	31487d8f256f16bd6244b7251be2ebb227ca54d864983f5dcd9e41bac98a75c7cc35707562980a9dd6dd1961cb21a75b44d0c5d6ea4c70fe	一般经营项目：园林设计、市政绿化、假山工艺、苗圃栽培。	1100	1130.0	2012-10-16 00:00:00	NaN	7	340200000000116750	341400000000015220	1	1	3.0	1.0	NaN	NaN	NaN	NaN	3.0	NaN	NaN	NaN	2367b4cac96d8598	260.0	260.0	NaN	NaN	NaN	1130
24864	9c7fa510616a68303d3427d4bfd4b0cf3e4843f2bf3f637a	340222	N	7830.0	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b10e34248d7725e1be837d17055e500a19ac3b984b12d80b78beb3abc694f1130f	各类广告设计、制作，不锈钢制品制作及销售（依法须经批准的项目，经相关部门批准后方可开展经营活动）	9600	9600.0	2011-05-27 00:00:00	NaN	6	340222070010000000	340200000020003395	1	1	1.0	1.0	NaN	NaN	10	NaN	3.0	NaN	NaN	NaN	31487d8f256f16bd6244b7251be2ebb27b17bdfd95c8f3b10e34248d7725e1be837d17055e500a19ac3b984b12d80b78beb3abc694f1130f	10.0	NaN	NaN	NaN	NaN	9600

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows